This example explains how to set up the POP Purchase Order (Single )layout so that you can email your purchase orders to preferred supplier contacts. You could use a similar approach for other purchase documents such as purchase returns.
This example explains how to:
Open: Report Designer > Report Designer.
Select the purchase order layout that you are using: File Explorer > Layouts .
From the Properties pane, select Email options and click .
Enter your email options:
From the Email message should contain: drop-down list, choose the group that matches the header section of the order layout .
For the POP Purchase Order (Single ) layout, select Group 6 - POPOrderReturns.POPOrderReturnID.
Click To....,and add the required recipients. To send your purchase orders to the preferred contact for each supplier, add the PL Supplier Accounts > ContactEmailAddress expression.
In the Expressions section, click Add .
Drag the following from the Fields pane to the Expression Editor section:
PL Supplier Accounts > ContactEmailAddress.
To copy this expression from a text file, click here.
Enter a Subject for the email:
This can be entered as text or you can use an expression to include information such as your company name and the order number.
Click Subject.
Drag the following from the Fields Pane:
SYSCompanies > CompanyName.
In the Expression Editor, enter + "Purchase Order No:" +
Note: To add more than one expression use + or and. If you want to include text with an expression use "quotation marks" around the text.
Drag the following from the Fields pane:
POPOrderReturns > DocumentNo.
The completed expression should be as follows:
SYSCompanies.CompanyName + " Purchase Order No: " + POPOrderReturns.DocumentNo.
To copy this expression from a text file, click here.
Choose whether to send the order as plain text or as an attachment.
If you want to send the report as plain text, you may have to amend the layout to make it suitable for an email message, as the layout is designed for printed output.
Note: Some layouts contain text that is designed to be read by a 3rd party document management add on available for Sage 200. This text is not designed to be printed but will appear when the document is sent as plain text. You may want remove this if you are sending your emails as plain text.
Enter a Filename for the attachment.
You can use an expression for this if you want the filename to include information such as your company name and the invoice number.
Click Subject.
Drag the following from the Fields Pane:
SYSCompanies > CompanyName.
In the Expression Editor, enter + "Purchase Order No:" +
Note: To add more than one expression use + or and. If you want to include text with an expression use "quotation marks" around the text.
Drag the following from the Fields pane:
POPOrderReturns > DocumentNo.
The completed expression should be as follows:
SYSCompanies.CompanyName + " Purchase Order No: " + POPOrderReturns.DocumentNo.
To copy this expression from a text file, click here.
Choose your email account provider.
Microsoft Outlook | Select this if you are using Microsoft Outlook 2003, 2007 or 2010. |
SMTP |
Select this if you send email using an SMTP provider such as Hotmail, Gmail or Yahoo Mail.
|
MAPI | Select this if your email application uses a MAPI (Outlook / Exchange) mail server. |
Note: You can set up a default email provider for all reports in Report Designer > Tools > Options | Email Setup.
To save the new order layout, select File > Save As.
When you change a default layout, letter or report, you must save the new layout, letter or report in the custom or company folder.
Choose to use the new purchase order layout.
Use an existing supplier role or set up a new one.
Open: ASM > Settings > Customer and Supplier Roles.
Associate this role with Purchase Order document type.
Open: ASM > Settings > Customer and Supplier Document Types.
Set up a Preferred Contact for the role with a valid email address for each supplier account that you want to send invoices to via email.
Open: PL > Purchase Accounts > Amend Account Details | Contacts.
Examples
Set up SOP invoices to send via email
Set up project invoices to send via email
Set up order acknowledgements to send via email
Set up despatch notes to send via email
Set up debtor letters to send via email
Other tasks
Overview